<?php

include_once 'common.php';

$sql = "SELECT `number`, `name`, `clientDepartment`, `clientOffice`, `clientGroup`, `clientRank`, `rank`, `TREX_LEVEL` FROM `oprec_security_data` WHERE `disposed` = 0 ORDER BY CONVERT(`name` USING gbk) ASC";
$result = exec_sql($sql);

output($result);